package com.netbao.fin.vomapper;

import com.netbao.fin.model.Total;
import com.netbao.model.PageBean;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author suqk
 * @create 2019-11-03 15:13
 */
public interface ShenVoMapper {
   // @Results({@Result(column = "cname",property = "captain.cname"),@Result(column = "phone",property = "captain.phone"),@Result(column = "cdeposit_bank",property = "captain.cdepositBank"),@Result(column = "account",property = "captain.account")})
    @Select("select * from fin_total where eid=#{eid}")
    List<Total> listAll(PageBean pageBean, Long eid);
    @Delete("delete from fin_total where id=#{id}")
    void exit(Long id);
    @Select("SELECT * FROM fin_total WHERE applicant LIKE '%${name}%' and eid=#{eid}")
    List<Total> mo(PageBean pageBean, String name, Long eid);
}
